package com.kaiyun.sharding.mapper.provide;


import com.baomidou.mybatisplus.core.metadata.IPage;

/**
 * 〈一句话功能简述〉
 * 〈功能详细描述〉
 *
 * @author zhanNaifeng
 * @see
 * @since
 */
public class  CourseInfoProvide {

    public String getList(IPage page,String name){
        String sql="select a.name,b.name userName from t_course_info a left join t_user_info b " +
            " on a.user_id =b.id where a.name like concat('%',#{name},'%')  order by a.id desc";
        return sql;
    }

    public String getList2(String name){
        String sql="select a.name,b.name userName from t_course_info a left join t_user_info b " +
            " on a.user_id =b.id where a.name like concat('%',#{name},'%')  order by a.id desc";
        return sql;
    }
}
